You will work on a small team to migrate legacy applicationsdeveloped in classic ASP (ActiveX), .NET Framework, and T-SQL to full stackASP.NET Core applications. We need a developer that can pull business logicfrom a code base written in VB6, classic asp, and T-SQL. Then work with businessowners to ensure the rules still apply or make any necessary changes. In anygiven day you might be asked to upgrade T-SQL scripts, migrate dynamic SQLbuilt in VB6 to a stored procedure, write Web API REST services, build webpages with Razor Pages/MVC, debug an ELT job, document a process. We also haveOracle databases and APEX, which is Oracle’s rapid development framework. Integrationwork with Oracle/APEX is possible. A good understanding of PL/SQL and APEX is aplus.
· Design and develop ASP.NET Core web applicationsusing the .NET Core development stack.
· Work within an older code base that has been maintainedby many developers over many years.
· Troubleshoot code using standard debugging toolslike the Visual Studio debugger and the browser’s dev tools to resolve applicationerrors.
· Use GIT source control management in a teamenvironment.
· Optimize large and complicated SQL scripts.
· Collaborate and communicate effectively withbusiness owners and team members.
· Document existing and new application features.
· Minimum 5 years of programing experience.
· Proficient in programming languages such as VB6,VBScript, C#, T-SQL, and PL/SQL
· Experienced in ASP.NET development (.NETFramework and .NET Core) with Entity Framework and/or ADO.NET.
· Experienced with Visual Studio and SQLManagement Studio development environments.
· Solid understanding of design patterns anddatabase normalization.
· Proven experience with extract, transform, andload (ETL) processing and SQL Server tools such as Integration Services, BCP.exe,and T-SQL Bulk Load.
· Working knowledge of scheduled jobs includingSQL Agent and Windows Scheduled Tasks.
· Experienced with GIT source control management.
· Strong understanding of browser side developmentincluding HTML, CSS, JavaScript
· Familiar with JavaScript libraries for buildinguser interface such as jQuery and React
· Oracle APEX and PL/SQL experience is a plus.
· Bachelor’s degree in computer science, otherrelated degrees, or equivalent application development experience.
| Skill | Required /Desired | Amount | of Experience |
|---|---|---|---|
| Proficient in programming languages such as VB6, VBScript, C#, T-SQL, and PL/SQL | Required | 5 | Years |
| Experienced in ASP.NET development (.NET Framework and .NET Core) with Entity Framework and/or ADO.NET. | Required | 5 | Years |
| Experienced with Visual Studio and SQL Management Studio development environments. | Required | 5 | Years |
| Solid understanding of design patterns and database normalization. | Required | 5 | Years |
| Proven experience with extract, transform, and load (ETL) processing and SQL Server tools such as Integration Services, BCP.exe, and T-SQL Bulk Load | Required | 5 | Years |
| Working knowledge of scheduled jobs including SQL Agent and Windows Scheduled Tasks. | Required | 5 | Years |
| Experienced with GIT source control management. | Required | 5 | Years |
| Strong understanding of browser side development including HTML, CSS, JavaScript | Required | 5 | Years |
| Familiar with JavaScript libraries for building user interface such as jQuery and React | Required | 5 | Years |
| Oracle APEX and PL/SQL experience is a plus. | Highly desired | 5 | Years |
| No. | Question |
|---|---|
| Question1 | Absences greater than two weeks MUST be approved by CAI management in advance, and contact information must be provided to CAI so that the resource can be reached during his or her absence. The Client has the right to dismiss the resource if he or she does not return to work by the agreed upon date. Do you accept this requirement? |
| Question2 | All work must be completed on-site. Do you accept this requirement? |
| Question3 | Candidate must be able to attend an in-person interview. Do you accept this requirement? |
| Question4 | Please list candidate’s email address. |
| Question5 | Please indicate how soon this candidate is available to start work. Vendors are encouraged to submit candidates that are available for the duration of the assignment. |
| Question6 | Vendor must disclose to the agency if the candidate will be subcontracted at the time of submission. Do you accept this requirement? |
| Question7 | Vendor must notify the agency if any portion of the requirements listed in this task order is to be outsourced to other countries. Do you accept this requirement? |
| Question8 | Candidates submitted above the rate of - will not be considered. Do you accept this requirement? |
| Question9 | Payment for all approved hours will be paid at the straight hourly rate regardless of the total hours worked by the engaged resource. It is the responsibility of the supplier to adhere to any applicable compensation laws including payment for overtime hours. Do you accept this requirement? |
| Question10 | Please confirm you have thoroughly validated, and attest to the accuracy of, the credentials listed throughout this candidate’s VectorVMS profile and resume pursuant to Section 5.2.5 of ITS-009440. Do you confirm? |